Parameters Provided:
name.synonym = CCRIS 7499; Curled mint oil; EPA Pesticide Code 128800; FEMA No. 3032; HSDB 1919; LS-145724; Mentha spicata oil; Mint oil; Oil of crispmint; Oil of curled mint; Oil of spearmint; Oils, mentha spicata; Oils, spearmint; SPEARMINT, OIL (MENTHA SPICATA L.); S
filter.purchasability = all
page.num = 1
Structural Results Found: (before additional filtering)
SQL Query Was
SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE 'CCRIS 7499; Curled mint oil; EPA Pesticide Code 128800; FEMA No. 3032; HSDB 1919; LS-145724; Mentha spicata oil; Mint oil; Oil of crispmint; Oil of curled mint; Oil of spearmint; Oils, mentha spicata; Oils, spearmint; SPEARMINT, OIL (MENTHA SPICATA L.); S' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id WHERE c.free = 1 ) LIMIT 50
Permalink
//zinc12.docking.org/results/combination?name.synonym=CCRIS+7499%3B+Curled+mint+oil%3B+EPA+Pesticide+Code+128800%3B+FEMA+No.+3032%3B+HSDB+1919%3B+LS-145724%3B+Mentha+spicata+oil%3B+Mint+oil%3B+Oil+of+crispmint%3B+Oil+of+curled+mint%3B+Oil+of+spearmint%3B+Oils%2C+mentha+spicata%3B+Oils%2C+spearmint%3B+SPEARMINT%2C+OIL+%28MENTHA+SPICATA+L.%29%3B+S&filter.purchasability=all
Embed Link to Results